﻿<%@ Page Title="Home Page" Language="vb" MasterPageFile="~/Site.Master" AutoEventWireup="false"
    CodeBehind="Default.aspx.vb" Inherits="Web_2._0_BMW___X6_Experts_Web_Application._Default" %>

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
    <style type="text/css">

        
        
        .LoginFunction
        {
            width: 245px;
            height: 168px;
        }
        .style4
        {
            font-size: x-large;
        }
        .Information
        {
            height: 318px;
            width: 594px;
        }
        .latestDiscussions2
        {
            width: 331px;
            height: 318px;
        }
        .title1
        {
        }
        .latestDisc4
        {
            height: 283px;
        }
        .MainImagert09aal
        {
            height: 150px;
        }
        .companyImages
    {
        height: 161px;
        text-align: center;
    }
        </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <div id="ContentBody">
<div style="border: thin solid #C0C0C0; height: 172px">

    <strong style="font-size:large; font-family: Calibri;"> X6 Experts is the site to visit when you need general and maintenance 
    help, guidance and to view the latest gallery of X6 images and videos. </strong>

    <br />
    <br />
    The BMW - X6 Experts specialise in BMW X6 Models to give our audience and X6 car 
    owners the help and guidance they require for a certain topic and area.

    <br />
    <br />
    If you&#39;re a registered user, you&#39;ll be able to take advantage of this service 
    and start your own interesting public discussion group, reply to other 
    discussions through posts, upload images and videos which you can tag and last 
    but not least have your own profile page which you can manage yourself. This 
    service is for everyone who is interested or owns BMW X6 cars to give them the 
    best expeience in a area in which they specialise in. &nbsp;&nbsp;
    <br />

</div>
    </div>
    <div class = "companyImages">
    
    
        <asp:Image ID="Image10" runat="server" BorderStyle="Solid" Height="139px" 
            ImageUrl="~/Pictures/bmw_silver.jpg" Width="195px" />
        <asp:Image ID="Image11" runat="server" BorderStyle="Solid" Height="139px" 
            ImageUrl="~/Pictures/bmw_repair1.jpg" style="text-align: center" 
            Width="195px" />
        <asp:Image ID="Image12" runat="server" BorderStyle="Solid" Height="139px" 
            ImageUrl="~/Pictures/bmw_white.jpg" Width="195px" />
    
    
    </div>

<div id="SecondContent">
<div class="latestDiscussions1">
    <div class="Information">
        <div class ="latestDiscussions3">
            <div class="title1" 
        
                style="background-color: #C0C0C0; font-size: x-large; height: 39px; text-align: center; width: 247px;">
                <strong>New Discussions</strong></div>
                <div class="latestDisc4">
        <asp:ListView ID="ListView1" runat="server" 
            DataSourceID="LatestDiscussionsSqlDataSource1">
            <AlternatingItemTemplate>
                <span style="">

                <strong>Discussion Created by:</strong>
                <asp:Label ID="UsernameLabel" runat="server" Text='<%# Eval("Username") %>' />
                <br />

                <strong>Title:</strong>
                <asp:Label ID="TitleLabel" runat="server" 
                Text='<%# Eval("Title") %>' />
                <br />

                <strong>Date Created:</strong>
                <asp:Label ID="DateCreatedLabel" runat="server" 
                    Text='<%# Eval("DateCreated") %>' />
                <br />
<br /></span>
            </AlternatingItemTemplate>
            <EditItemTemplate>
                <span style="">

                <strong>Discussion Created by:</strong>
                <asp:TextBox ID="UsernameTextBox" runat="server" 
                    Text='<%# Bind("Username") %>' />
                <br />

                <strong>Title:</strong>
                <asp:TextBox ID="TitleTextBox" runat="server" 
                    Text='<%# Bind("Title") %>' />
                <br />

                <strong>Date Created:</strong>
                <asp:TextBox ID="DateCreatedTextBox" runat="server" 
                    Text='<%# Bind("DateCreated") %>' />
                <br />


                <asp:Button ID="UpdateButton" runat="server" CommandName="Update" 
                    Text="Update" />
                <asp:Button ID="CancelButton" runat="server" CommandName="Cancel" 
                    Text="Cancel" />
                <br /><br /></span>

            </EditItemTemplate>
            <EmptyDataTemplate>
                <span>Sorry no data has been returned, please try refreshing your browser.</span>
            </EmptyDataTemplate>
            <InsertItemTemplate>
                <span style="">
                
                <strong>Discussion Created by:</strong>
                <asp:TextBox ID="UsernameTextBox" runat="server" 
                    Text='<%# Bind("Username") %>' />
                <br />
                
                <strong>Title:</strong>
                <asp:TextBox ID="TitleTextBox" runat="server" Text='<%# Bind("Title") %>' />
                <br />
                
                
                <strong>Date Created:</strong>
                <asp:TextBox ID="DateCreatedTextBox" runat="server" 
                    Text='<%# Bind("DateCreated") %>' />
                <br />
                
                

                <asp:Button ID="InsertButton" runat="server" CommandName="Insert" 
                    Text="Insert" />
                <asp:Button ID="CancelButton" runat="server" CommandName="Cancel" 
                    Text="Clear" />
                <br /><br /></span>
            </InsertItemTemplate>
            <ItemTemplate>
                <span style="">
                <strong>Discussion Created by:</strong>
                <asp:Label ID="UsernameLabel" runat="server" Text='<%# Eval("Username") %>' />
                <br />
                <strong>Title:</strong>
                <asp:Label ID="TitleLabel" runat="server" 
                    Text='<%# Eval("Title") %>' />
                <br />
                <strong>Date Created:</strong>
                <asp:Label ID="DateCreatedLabel" runat="server" 
                    Text='<%# Eval("DateCreated") %>' />
                <br />
<br /></span>
            </ItemTemplate>
            <LayoutTemplate>
                <div ID="itemPlaceholderContainer" runat="server" style="">
                    <span runat="server" id="itemPlaceholder" />
                </div>
                <div style="">
                </div>
            </LayoutTemplate>
            <SelectedItemTemplate>
                <span style="">Discussion Created by:
                <asp:Label ID="UsernameLabel" runat="server" Text='<%# Eval("Username") %>' />
                <br />
                Title:
                <asp:Label ID="TitleLabel" runat="server" 
                    Text='<%# Eval("Title") %>' />
                <br />
                Date Created:
                <asp:Label ID="DateCreatedLabel" runat="server" 
                    Text='<%# Eval("DateCreated") %>' />
                <br />
<br /></span>
            </SelectedItemTemplate>
        </asp:ListView>
        <br />
        <br />
        <asp:SqlDataSource ID="LatestDiscussionsSqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
            
            
           
            
            
            
            
                        
                        SelectCommand="SELECT TOP 2 Discussion.Title, Discussion.DateCreated, aspnet_Users.UserName, Discussion.DiscussionID FROM (Discussion INNER JOIN aspnet_Users ON Discussion.UserIDFK = aspnet_Users.UserId) ORDER BY Discussion.DiscussionID DESC">
        </asp:SqlDataSource>
    </div>
</div>
<div class ="latestDiscussions2" style="border: thin dashed #000000">
<div class="List1" style="font-style: normal; width: 276px;"><strong>View and Post Discussions</strong> for people to read and reply to.</div>

<div class="List2"><strong>Retrieve Maintenance</strong> help from others through discussions and 
    videos / images. </div>
<div class="List3"><strong>Upload Images</strong> of fancy X6 models to show off kitted up X6&#39;s and 
    get rated by other users.</div>
<div class="List4"><strong>Upload Videos</strong> of X6 Car shows, races, maintenance issues and 
    help.&nbsp; </div>
    <div class="MainImagert09aal">
        
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        
        <asp:Image ID="Image2" runat="server" Height="142px" 
            ImageUrl="~/Pictures/lumma-clr-x-650-gt-bmw-x6-1.jpg" Width="252px" />
    </div>

</div>
</div>
<div style="text-align: center; height: 38px; width: 311px; background-color: #CCCCCC;" 
        class="style4">
    <strong>Latest Image Uploaded</strong></div>
<div style="height: 303px; width: 315px;">
 
    <asp:FormView ID="FormView1" runat="server" 
        DataSourceID="LatestImagesUploadedSqlDataSource1" Height="16px" 
        Width="311px" style="margin-bottom: 11px">
        <EditItemTemplate>
            ***Image***:
            <asp:TextBox ID="ImageLinkTextBox" runat="server" 
                Text='<%# Bind("ImageLink") %>' />
            <br />
            Image Description:
            <asp:TextBox ID="ImageDescriptionTextBox" runat="server" 
                Text='<%# Bind("ImageDescription") %>' />
            <br />
            Date Uploaded:
            <asp:TextBox ID="DateUploadedTextBox" runat="server" 
                Text='<%# Bind("DateUploaded") %>' />
            <br />
            Uploaded by:
            <asp:TextBox ID="UsernameTextBox" runat="server" 
                Text='<%# Bind("Username") %>' />
            <br />
            <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" 
                CommandName="Update" Text="Update" />
            &nbsp;<asp:LinkButton ID="UpdateCancelButton" runat="server" 
                CausesValidation="False" CommandName="Cancel" Text="Cancel" />
        </EditItemTemplate>
        <InsertItemTemplate>
            ImageLink:
            <asp:TextBox ID="ImageLinkTextBox" runat="server" 
                Text='<%# Bind("ImageLink") %>' />
            <br />
            Image Description:
            <asp:TextBox ID="ImageDescriptionTextBox" runat="server" 
                Text='<%# Bind("ImageDescription") %>' />
            <br />
            Date Uploaded:
            <asp:TextBox ID="DateUploadedTextBox" runat="server" 
                Text='<%# Bind("DateUploaded") %>' />
            <br />
            Uploaded by:
            <asp:TextBox ID="UsernameTextBox" runat="server" 
                Text='<%# Bind("Username") %>' />
            <br />
            <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" 
                CommandName="Insert" Text="Insert" />
            &nbsp;<asp:LinkButton ID="InsertCancelButton" runat="server" 
                CausesValidation="False" CommandName="Cancel" Text="Cancel" />
        </InsertItemTemplate>
        <ItemTemplate>
            <strong>***Image***</strong>
            <br />
            
            <asp:Image ID="Image1" runat="server" Height="200px" ImageUrl='<%# Eval("ImageLink") %>' Width="300px"  />
            <br />
            <strong>Image Description:</strong>
            <asp:Label ID="ImageDescriptionLabel" runat="server" 
                Text='<%# Bind("ImageDescription") %>' />
            <br />
            <strong>Date Uploaded:</strong>
            <asp:Label ID="DateUploadedLabel" runat="server" 
                Text='<%# Bind("DateUploaded") %>' />
            <br />
            <strong>Uploaded by:</strong>
            <asp:Label ID="UsernameLabel" runat="server" Text='<%# Bind("Username") %>' />
            <br />

        </ItemTemplate>
    </asp:FormView>




    <asp:SqlDataSource ID="LatestImagesUploadedSqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
        
        
        
        
        
        
        SelectCommand="SELECT TOP 1 Images.ImageLink, Images.ImageDescription, Images.DateUploaded, aspnet_Users.UserName, Images.ImageID FROM (Images INNER JOIN aspnet_Users ON Images.UserIDFK = aspnet_Users.UserId) ORDER BY Images.ImageID DESC">
    </asp:SqlDataSource>
    <br />
    <br />
</div>
</div>
</div>

</asp:Content>